home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Diamond Collection
/
The Diamond Collection (Software Vault)(Digital Impact).ISO
/
cdr02
/
fwsb30z4.zip
/
11.DOC
< prev
next >
Wrap
Text File
|
1993-02-08
|
8KB
|
193 lines
Example Use of FW
=================
Financial Wonder's operation is unique in the market.
FW will use your computer's potential like few other financial
programs can.
Let's see how it works!
-----------------------
FW provides you with a ready-to-go worksheet containing over 250
financial accounts. These accounts are all pre-programmed.
* First, change any account descriptions to your liking.
* Add new sub-accounts to the existing accounts.
Example: Add 10 new Sales, Accounts Receivable and Cost of Sales
accounts. Maybe even link the A/R and COS accounts to
change as the individual Sales accounts change.
Thousands of new sub-accounts may be added.
* Next select the structure of your Data Entry. FW allows you to enter
your Data monthly, quarterly or annually. Mixtures for each year are
acceptable. For our example we will use 3 annual periods of Data Entry.
* Enter your opening balance sheet amounts. (This would also be your
most recent ending balances, to be used for the start of your 3 year
forecast).
* Select your formula methods and enter your amounts or growth
percentages to be forecast into the 3 (annual) columns. Each cell
may use a different formula method.
THAT'S IT!
==========
FW will create 36 complete sets of MONTHLY financial statements and
ratio analysis, and display the results right on the screen.
FUTURE
------
A future version will allow 10 to 20 years of monthly
financials, with the same limit of 5000 accounts per file.
Let's see how FW calculates your files!
FW performs these steps in the following order - Automatically!
---------------------------------------------------------------
1) Calculate forecasted amounts for the 1st month of the 1st year.
2) Determine cash flow for that month.
a) Increase "Marketable Securities" for positive cash flow,
b) Increase "Additional Loans" for negative cash flow,
c) Or reduce Marketable Securities or Additional Loans cumulative
from previous months.
3) Calculate interest income/expense on cumulative Marketable Securities
or Additional Loans.
a) Interest is based on 30 days for previous months
b) Days of interest is user selectable for the current month
c) Different rates of interest & # of days for int income & int exp
4) Tax-effect the interest on cash flow
5) Update the B/S , I/S , C/S , and ratio analysis for:
a) Marketable Securities & Additional Loans
b) Retained Earnings
c) Interest income & interest expense
d) Tax expense
6) FW WILL THEN REPEAT ALL OF THE ABOVE FOR EACH OF THE 36 MONTHLY
PERIODS.
All this is accomplished in under 1 minute !
And all Automatically !
OK! Let's look at what we have
------------------------------
* FW displays 3 sets of financial screens
a) Data Entry & Formula Entry
b) Calculation (by Data Entry period)
c) Monthly Calculation
* In the previous example the Data Entry screens would show an
opening B/S and 3 Data Entry columns.
* Monthly Calculation screens contain an opening B/S and 36 monthly
calculated columns of results in dollars.
* Calculation screens always contain the same columns as the Data
Entry screens. The Monthly Calculation screen results are summarized
in the same structure (month/quarter/annual) as your original forecast.
This makes your analysis of the results very easy!
It also acts as a summarizer for reports.
Let's look at a Special Management Tool for ratio analysis
----------------------------------------------------------
* FW will let you grade yourself. You determine 5 levels of acceptability,
"Excellent to Poor", for each ratio.
Example: Gross Profit of 50% might be excellent, 35% being poor,
with 3 other levels in-between.
* The 36 monthly results plus your grades, "Excellent to Poor", will be
displayed for each ratio. Short to-the-point descriptions and analysis
are displayed for each ratio.
Let's produce some reports
--------------------------
* FW has a ONE-KEY export to Lotus 1-2-3. Select which reports you would
like by pressing (Y) for Yes. THAT'S IT!
Polished Lotus files with $ signs, totals, lines drawn and range
names will be created for you in just a minute or two.
FASB 95 Cash Statements can also be produced using either the
direct or indirect method.
* Print drivers for 600 printers using up to 43 different fonts
(printer dependent) are provided. LaserJets, dot matrix & daisey
wheel printers are supported.
* Printouts of screens (includes account numbers & ratios on C/S)
Data Entry & Formula Entry
Calculation
Monthly Calculation
* Report printing (formal looking reports & ratios on C/S)
Calculation
Monthly Calculation
FASB 95 Cash Statements
Save up to 20 different report formats with each file. Print
detailed or summarized reports. You can roll-up selected
sub-accounts into their main account, or even have the main
account rolled-up.
Example: With 10 Accounts Receivable sub-accounts you could roll-up
the amounts from, say, 7 of the 10 into the main A/R
account. These 7 accounts would not print out. Maybe even
roll-up these 7 accounts and the main A/R account into
"Other Current Assets".
Fine tune your numbers with our REPORT MODE
-------------------------------------------
First use our formula methods to create your monthly forecast. Then enter
the REPORT MODE and work with the monthly results (in dollar amounts).
You may directly change any calculated amount in any month. You may even
add new sub-accounts. The REPORT MODE will re-calculate tax expense,
re-calculate cash flow + tax-effect and update all financials, revise
the cash statement and all ratios, and will re-add all totals.
Monthly amounts can then be summarized by month, quarter and annual periods
under "Calc screen".
THAT'S IT!
To enter the REPORT MODE simply call up the saved BUDGET file as a REPORT
MODE file.
Options for taxation, present value, and interest on cash flow are
available.
Extras to think about
---------------------
* Files created with FW can be used to create templates for future use.
Once a particluar file is created, its setup can be reused.
* The Data Entry structure can also be changed. Columns can be "Inserted"
or "Deleted". An annual Data Entry column can be re-cast as a quarterly
column, with 3 additional columns "Inserted" in front of the re-cast
column.
These new columns could just as easily be "Deleted".
FW can operate with a mixture of monthly, quarterly & annual columns.
You might wish to use quarterly columns in the 1st year for greater
flexibility. The first quarter might then be converted to monthly
columns to enter actuals for the first 3 months. Then re-calculate
the budget and see how the actual results affect your forecast.